﻿CREATE TABLE [dbo].[LfdNr] (
    [PrefixAngebot]  NVARCHAR (5) COLLATE Latin1_General_CI_AS NULL,
    [Angebot]        INT          DEFAULT ((0)) NULL,
    [PrefixRechnung] NVARCHAR (5) COLLATE Latin1_General_CI_AS NULL,
    [Rechnung]       INT          DEFAULT ((0)) NULL
);


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'DateCreated', @value = N'97-06-26 19:53:43', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'LastUpdated', @value = N'97-06-26 19:53:44', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'MS_OrderByOn', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'LfdNr', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'RecordCount', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'Updatable', @value = N'True', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PrefixAngebot', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'5', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PrefixAngebot', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'LfdNr', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixAngebot';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Angebot', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Angebot', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'LfdNr', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Angebot';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'PrefixRechnung', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'2', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'5', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'PrefixRechnung', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'LfdNr', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'10', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'PrefixRechnung';


GO
EXECUTE sp_addextendedproperty @name = N'AllowZeroLength', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'AppendOnly', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Attributes', @value = N'1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'CollatingOrder', @value = N'1033', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnHidden', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnOrder', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'ColumnWidth', @value = N'-1', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'DataUpdatable', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'DefaultValue', @value = N'0', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DecimalPlaces', @value = N'255', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DisplayControl', @value = N'109', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Name', @value = N'Rechnung', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'OrdinalPosition', @value = N'3', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Required', @value = N'False', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Size', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceField', @value = N'Rechnung', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'SourceTable', @value = N'LfdNr', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';


GO
EXECUTE sp_addextendedproperty @name = N'Type', @value = N'4', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'LfdNr', @level2type = N'COLUMN', @level2name = N'Rechnung';

